from pymysql import connect

connection = connect(host='localhost', port=3306, db='bjsxt', user='root', password='root', charset='utf8')

cursor = connection.cursor()
# sql = 'insert into employees (employee_id,first_name,last_name,email,hire_date,job_id) values ' \
#       '(31494327,"李","金球","31494327@qq.com","2025-02-25 00:00:00","IT_PROG");'

# sql = 'update employees set salary=40000,commission_pct=50 where employee_id=31494327;'
sql = 'delete from employees  where employee_id=31494327;'
result = cursor.execute(sql)
print(result)

connection.commit()
